<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!-- InstanceBegin template="/Templates/anydbtest.dwt" codeOutsideHTMLIsLocked="false" -->
    <!-- InstanceBeginEditable name="doctitle" -->
    <title>Benefits of AnyDbTest </title>
    <!-- InstanceEndEditable -->
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <meta name="AnyDbTest" content="AnyDbTest Technology">
     
    <meta name="robots" content="index,follow">
    <meta name="generator" content="AnyDbTest">
    <meta name="author" content="AnyDbTest Technology">
    <meta name="rating" content="General">
    <meta name="revisit-after" content="2 days">
    <meta name="classification" content="Science &amp; Technology">
    <meta name="distribution" content="Global">
    <link rel="stylesheet" type="text/css" href="style.css">
    <!-- InstanceBeginEditable name="head" -->
    <meta name="keywords" content="AnyDbTest, UnitTest, Database UnitTest, DB UnitTest, Database automatic test,  Unit test, Database Unit test, DB Unit test, DB automatic test - AnyDbTest Technology">
    <meta name="description" content="AnyDbTest Technology is devoted to developing intuitive, easy-to-use application and database software products for different categories of users.  ">
    <!-- InstanceEndEditable -->

    <script type="text/JavaScript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
    </script>

</head>
<body>
    <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
            <td colspan="3">
                <img src="images/logo.png" width="960" height="87" border="0" usemap="#Map" onclick="MM_preloadImages('images/logo.png')" />
            </td>
        </tr>
        <tr>
            <td width="9" background="images/layout/site-left.gif">
                &nbsp;
            </td>
            <td width="942" height="37" background="images/layout/menu-bg.gif" onfocus="MM_preloadImages('images/layout/menu-bg.gif')">
                <table border="0" cellpadding="0" cellspacing="0">
                    <tbody>
                        <tr>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="index.html">Home</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="product.html">Product</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="download.html">Download</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="purchase.html">Purchase</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="support.html">Support</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="tutorial.html">Tutorial</a></div>
                            </td>
                            <!--
            <td class="MenuTop" width="120">
            <div align="center"><a href="affiliate.html">Affiliate</a></div>
            </td>
            -->
                        </tr>
                    </tbody>
                </table>
            </td>
            <td width="10" background="images/layout/site-right.gif">
                &nbsp;
            </td>
        </tr>
            <tr>
                <td colspan="3" background="images/layout/site-bg.gif">
                    <table border="0" cellpadding="0" cellspacing="0" width="960">
                        <tbody>
                            <tr>
                                <td height="50" width="9">
                                    &nbsp;
                                </td>
                                <td class="productText" bgcolor="#ffffff" valign="top" width="716">
                                    <div class="LeftColumnPadding">
                                        <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                            <tbody>
                                                <tr>
                                                    <td class="productText">
                                                        <p align="justify">
                                                        
                                                        <h2>Challenges <a name="ProductChallenges" id="ProductChallenges"></a></h2>
                                                        In many development projects, we have to accept the fact that it is lack of unit tests for views/stored procedures because we have no handy DB unit testing tool. The typical scenario is, 
                                                        <br />
                                                        <br />
                                                        During testing some views/stored procedures did not return the data that they should have. Developers seemed to take the database code for granted and did not develop unit tests for all of the code parts that relied on the database code. At the same time, the database team was fine with writing code, testing it manually, and assuming that it worked correctly. The truth is that both developers and DBAs were at fault. There was weak informal communication/cooperation in writing these views and stored procedures. 
                                                        <br />
                                                        <br />
                                                        One best practice, we should treat views and stored procedures like any other code. They should be covered by the unit test suite.
                                                        <br />
                                                        <br /> 
                                                        Beyond that, as a development leader or a professional DBA who involved in business-critical applications, you know about application development <strong>challenges</strong>:
                                                        <br />
                                                        <ul>
                                                            <li>How to minimize the bug leakage from DB developers?</li>
                                                            <br />
															<li>How to gain benefits from unit testing in DB development phase? </li>
                                                            <br />
															<li>How to prepare the test data for stored procedures/SQL scripts? </li>
                                                            <br />
															<li>Improve the performance of legacy stored procedures/SQL scripts, but make sure the new scripts should have the same result in any conditions. </li>
                                                        </ul>
                                                        These are not simple problems to overcome. To succeed your database you must first know the exact state of the database. You should be able to easily organize a big amount of test
                                                        data and be able to verify result of DB script, in many cases the results often contain a lot of records.
                                                        <br />
                                                        <br />
                                                        <strong>With AnyDbTest, you can embrace all these challenges with fewer resources, in less time, and for less money. </strong>See a dramatic, positive impact on your business by AnyDbTest.
                                                        <br>

                                                        <h2>Benefits<a name="ProductBenefits" id="ProductBenefits"></a></h2>    
                                                        <ul>
                                                            <li>Deliver the bug-free stored procedures/SQL scripts.</li>
                                                            <br />
															<li>Streamlining processes between DBA/DB developers and application developers.</li>
                                                            <br />
															<li>Increasing collective confidence of your development team.</li>
                                                            <br />
															<li>Easy to perform regression database unit testing.</li>
                                                            <br />
															<li>Be able to manage the state of a database throughout a test&#145;s lifecycle enables rapid test-case creation and adoption .</li>
                                                            <br />
															<li>Boosting projects success rates from the get-go.</li>
                                                        </ul>
                                                        </p>
                                                    </td>
                                               </tr>
                                            </tbody>
                                        </table>
                                        <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                            <tbody>
                                                <tr>
                                                    <td>
                                                        <div align="right">
                                                            <span class="productButtons"><strong><a href="download.html#DownloadAnyDbTest">
                                                                <img src="images/layout/download-button.jpg" alt="Download" border="0" height="26" width="101">&nbsp;</a> </strong><strong><a href="purchase.html#OrderSection">
                                                                    <img src="images/layout/purchase-button.jpg" alt="Purchase Now" border="0" height="26" width="101">&nbsp;</a> </strong></span>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </td>
                                <td background="images/layout/right-column-bg.gif" valign="top" width="226">
                                    <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                        <tbody>
                                            <tr>
                                                <td class="rightColumn">
                                                    &nbsp;
                                                </td>
                                            </tr>
                                            <tr>
                                                <td valign="top">
                                                    <div class="RightColumnPadding">
                                                        <!-- InstanceBeginEditable name="RightRegion" -->
                                                        <table border="0" cellpadding="0" cellspacing="0" width="96%">
                                                            <tbody>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="product.html">Overview</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductBenefits.html">Benefits</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductFeatureList.html">Feature List</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductOtherToolsComp.html">Compare other tools</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductEditionComp.html">Edition comparison</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductScreenshots.html">Screenshots </a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductChangeLog.html">What's new</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td colspan="3">
                                                                        &nbsp;
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>

                                                        <script type="text/javascript">
                                                        var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
                                                        document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
                                                        </script>
                                                        <script type="text/javascript">
                                                        try {
                                                        var pageTracker = _gat._getTracker("UA-8398936-1");
                                                        pageTracker._trackPageview();
                                                        } catch(err) {}</script>

                                                        <!-- InstanceEndEditable -->
                                                        <br>
                                                        <div align="center">

                                                            <script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/translatemypage.xml&up_source_language=en&w=160&h=60&title=&border=&output=js"></script>

                                                        </div>
                                                        <!-- InstanceBeginEditable name="RightRegion" -->
                                                         
                                                        <!-- InstanceEndEditable -->
                                                        <br>
                                                    </div>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </td>
                                <td width="9">
                                    &nbsp;
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </td>
            </tr>
            <tr>
                <td height="46" colspan="3" valign="middle" background="images/layout/site-border-bottom-full.gif" onfocus="MM_preloadImages('images/layout/site-border-bottom-full.gif')">
                    <table width="362" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td width="12" class="menuBottom">
                                &nbsp;
                            </td>
                            <td width="350" class="BottomLinks">
                                &nbsp;&nbsp; <a href="index.html">About AnyDbTest</a>&nbsp;&nbsp;|&nbsp;&nbsp; <a href="license.html">Terms of Usage</a>&nbsp;&nbsp;|&nbsp;&nbsp; <a href="privacy.html">Privacy Policy</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                                <!--
        		<a href="customers.html">Our Clients</a>
                -->
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNotice">
                    &nbsp;
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNotice">
                    <span class="copyrightNotice">Copyright &copy; 2008 - 2010 AnyDbTest Technology. All rights reserved.</span>
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNoticeProducts">
                    <span class="copyrightNoticeProducts">AnyDbTest are trademarks or registered trademarks of AnyDbTest Technology.</span>
                </td>
            </tr>
        </tbody>
    </table>
    <br>
    <map name="Map" id="Map">
        <area shape="rect" coords="22,19,257,80" href="index.html" alt="AnyDbTest">
    </map>
    <!-- InstanceEnd -->
</body>
</html>
